select * from products where pro_name like '%Spring%dresses%' or pro_des like '%Spring%dresses%'union all select * from products where (pro_name like '%Spring%' or pro_des like '%Spring%') or(pro_name like '%dresses%' or pro_des like '%dresses%') and (pro_name not like '%Spring%dresses%' or pro_des not like '%Spring%dresses%')

Beaded and Ruched Hot Pink Dresses for A Quinceanera with Ruffles

Appliques and Ruffles Accent Dress for a Quinceanera in Coral Red

Hot Pink Satin and Organza Dresses for A Quinceanera with Ruffles

Two Toned Blue Dresses for A Quinceanera with Feather and Ruffles

Beaded and Ruffled Dress for a Quinceanera in Orange and Rose Pink

Embroidered Hot Pink v Neck Sweet Sixteen Dresses with Court Train

Blue and White Strapless Sweet Sixteen Dresses with Beading Flowers

Appliqued Organza Sweetheart Sweet Sixteen Dresses in Lavender

Beaded White and Blue Taffeta Sweet Sixteen Dresses with Pick ups

Red Halter Organza Embroidery and Ruffled Sweet Sixteen Dresses

Lavender Taffeta Strapless Sweet 15 Dresses with Pick ups Flowers

Purple One Shoulder Sweet 15 Dress with Appliques and Zebra Print

Fashionable Purple and White Organza Sweet 15 Dresses with Appliques Jersey Shore dress

Appliques and Pick ups Accent Sweet 15 Dresses in Blue and Green

Beaded Blue Sweet 15 Dresses with Olive Green Sash and Pick ups

Blue and Red Ruffles Embroidery Quinceanera Gown Dresses 2013

Appliques and Pick ups Accent Royal Blue Quinceanera Gown Dress

Strapless Beading Black Frills Quinceanera Gown Dresses

Appliques and Pick ups Quinceanera Gown Dresses in Olive Green

Blue Organza Quinceanera Gown Dresses with Appliques Pick ups

Dark Purple One Shoulder Quinceanera Gowns with Beading Flower

Black Appliques Accent Turquoise Taffeta Quinceanera Gown Straps

Lavender One Shoulder Quinceanera Gowns with Appliques and Flowers

Appliqued Purple Organza Quinceanera Gowns with Leopard Print

Appliques and Pick ups Accent Quinceanera Gowns of Lavender Organza

Straps Green Taffeta Quinceanera Dresses with Pick ups Embroidery

Red Taffeta and Organza Quinceanera Dresses with Beading Ruffles

Embroidery and Pick ups Accent Quinceanera Dresses in Lavender

Ruffled White Quinceanera Dresses with Appliques and Brush Train

Embroidered and Ruffled Quinceanera Dresses in Bud Green 2013